/*
 Navicat Premium Dump SQL

 Source Server         : local-oracle
 Source Server Type    : Oracle
 Source Server Version : 210000 (Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production)
 Source Host           : localhost:1521
 Source Schema         : PDBADMIN

 Target Server Type    : Oracle
 Target Server Version : 210000 (Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production)
 File Encoding         : 65001

 Date: 23/02/2025 11:12:39
*/


-- ----------------------------
-- Table structure for USER_INFO
-- ----------------------------
DROP TABLE "PDBADMIN"."USER_INFO";
CREATE TABLE "PDBADMIN"."USER_INFO" (
  "ID" NUMBER(11,0) VISIBLE DEFAULT "PDBADMIN"."ISEQ$$_76754".nextval NOT NULL,
  "NAME" VARCHAR2(255 BYTE) VISIBLE DEFAULT '',
  "AGE" NUMBER(3,0) VISIBLE DEFAULT 0,
  "CREATED_AT" DATE VISIBLE DEFAULT CURRENT_TIMESTAMP
)
LOGGING
NOCOMPRESS
PCTFREE 10
INITRANS 1
STORAGE (
  INITIAL 65536 
  NEXT 1048576 
  MINEXTENTS 1
  MAXEXTENTS 2147483645
  BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
DISABLE ROW MOVEMENT
;
COMMENT ON COLUMN "PDBADMIN"."USER_INFO"."ID" IS 'id';
COMMENT ON COLUMN "PDBADMIN"."USER_INFO"."NAME" IS '姓名';
COMMENT ON COLUMN "PDBADMIN"."USER_INFO"."AGE" IS '年龄';
COMMENT ON COLUMN "PDBADMIN"."USER_INFO"."CREATED_AT" IS '创建时间';
COMMENT ON TABLE "PDBADMIN"."USER_INFO" IS '人员';

-- ----------------------------
-- Records of USER_INFO
-- ----------------------------
INSERT INTO "PDBADMIN"."USER_INFO" VALUES ('1', 'tommy', '18', TO_DATE('2025-01-06 12:09:22', 'SYYYY-MM-DD HH24:MI:SS'));
INSERT INTO "PDBADMIN"."USER_INFO" VALUES ('2', 'aodi', '5', TO_DATE('2025-01-06 12:09:41', 'SYYYY-MM-DD HH24:MI:SS'));

-- ----------------------------
-- Sequence structure for ISEQ$$_76754
-- ----------------------------
DROP SEQUENCE "PDBADMIN"."ISEQ$$_76754";
CREATE SEQUENCE "PDBADMIN"."ISEQ$$_76754" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 CACHE 20;

-- ----------------------------
-- Checks structure for table USER_INFO
-- ----------------------------
ALTER TABLE "PDBADMIN"."USER_INFO" ADD CONSTRAINT "SYS_C008220" CHECK ("ID" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
